if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mast_view]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[Mast_view]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mast_view1]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[Mast_view1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp1]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[temp1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp11]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[temp11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Can_Prop]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Can_Prop]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Crime_Det]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Crime_Det]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Dist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Dist]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Fam_Det]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Fam_Det]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Grampan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Grampan]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jati]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jati]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KhetraPan_Mem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KhetraPan_Mem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_details]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Member_details]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM2]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM3]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM3]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM4A]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM4A]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM4B1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM4B1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM4B2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM4B2]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM4B3]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM4B3]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM4B4]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM4B4]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM4B5]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM4B5]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM5A]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM5A]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM5B]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM5B]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM6]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM6]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOMINATION]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOMINATION]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NOM_PAPER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NOM_PAPER]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Nagar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Nagar]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Per11]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Per11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Per8]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Per8]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Per81]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Per81]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Per82]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Per82]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa10]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa10]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa21A]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa21A]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa3]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa3]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa34]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa34]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa41]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa41]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa42]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa42]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa5]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa5]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa6]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa6]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa7]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa7]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa91]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa91]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Performa92]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Performa92]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pradhan_Gram]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Pradhan_Gram]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pramuk_Khestra]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Pramuk_Khestra]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Reservation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Reservation]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Reservation1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Reservation1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Reservation_ward]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Reservation_ward]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Reservation_ward1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Reservation_ward1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Result_Pradhan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Result_Pradhan]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Result_Pres]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Result_Pres]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Result_Zilamember]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Result_Zilamember]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Result_bdcmember]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Result_bdcmember]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Result_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Result_temp]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Result_wardmember]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Result_wardmember]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[S_Jati]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[S_Jati]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Seat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Seat]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Seat_Details]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Seat_Details]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Seat_Details1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Seat_Details1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tah]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Tah]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tah1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Tah1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Voter_list_nigam]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Voter_list_nigam]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Voter_list_nigam1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Voter_list_nigam1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Ward_Member]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Ward_Member]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ZilaPan_Mem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ZilaPan_Mem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[data]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[data]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ele_loc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ele_loc]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ele_loc1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ele_loc1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ele_loc_nigam]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ele_loc_nigam]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ele_loc_nigam1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ele_loc_nigam1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[voter_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[voter_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[voter_list1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[voter_list1]
GO

CREATE TABLE [dbo].[Can_Prop] (
	[dnm] [nvarchar] (30) NULL ,
	[snm] [nvarchar] (30) NULL ,
	[totc] [int] NULL ,
	[c1] [int] NULL ,
	[c2] [int] NULL ,
	[e1] [int] NULL ,
	[e2] [int] NULL ,
	[e3] [int] NULL ,
	[yr] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Crime_Det] (
	[dnm] [nvarchar] (30) NULL ,
	[snm] [nvarchar] (30) NULL ,
	[totc] [int] NULL ,
	[c1] [int] NULL ,
	[c2] [int] NULL ,
	[e1] [int] NULL ,
	[e2] [int] NULL ,
	[e3] [int] NULL ,
	[e4] [int] NULL ,
	[e5] [int] NULL ,
	[yr] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Dist] (
	[dcd] [int] NOT NULL ,
	[dnm] [nvarchar] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Fam_Det] (
	[dnm] [nvarchar] (30) NULL ,
	[snm] [nvarchar] (30) NULL ,
	[totc] [int] NULL ,
	[c1] [int] NULL ,
	[c2] [int] NULL ,
	[e1] [int] NULL ,
	[e2] [int] NULL ,
	[e3] [int] NULL ,
	[e4] [int] NULL ,
	[e5] [int] NULL ,
	[e] [int] NULL ,
	[yr] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Grampan] (
	[dcd] [int] NULL ,
	[tcd] [int] NULL ,
	[gcd] [int] NULL ,
	[grampan] [nvarchar] (30) NULL ,
	[city] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Jati] (
	[jcd] [int] NOT NULL ,
	[jnm] [nvarchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KhetraPan_Mem] (
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[gram_ward] [nvarchar] (30) NULL ,
	[res] [nvarchar] (30) NULL ,
	[yr] [nvarchar] (5) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Member_details] (
	[sn] [int] NULL ,
	[sno] [nvarchar] (10) NOT NULL ,
	[name] [nvarchar] (30) NULL ,
	[fh_name] [nvarchar] (30) NULL ,
	[sex] [nvarchar] (10) NULL ,
	[age] [int] NULL ,
	[jnm] [nvarchar] (30) NULL ,
	[sjnm] [nvarchar] (50) NULL ,
	[edu] [nvarchar] (20) NULL ,
	[income] [nvarchar] (20) NULL ,
	[child] [bit] NOT NULL ,
	[exp_child_edu] [bit] NOT NULL ,
	[income_source] [nvarchar] (30) NULL ,
	[pan_card] [bit] NOT NULL ,
	[income_tax_pend] [bit] NOT NULL ,
	[tot_prop_source] [bit] NOT NULL ,
	[govt_pend_tax] [bit] NOT NULL ,
	[cr_det_give] [bit] NOT NULL ,
	[cr_rel] [bit] NOT NULL ,
	[cr_rel_aff] [bit] NOT NULL ,
	[cr_prove_pun] [bit] NOT NULL ,
	[cr_release] [bit] NOT NULL ,
	[pend_court] [bit] NOT NULL ,
	[alligation_pun] [bit] NOT NULL ,
	[yr] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM1] (
	[SNO] [nvarchar] (5) NULL ,
	[S11] [nvarchar] (20) NULL ,
	[S12] [nvarchar] (20) NULL ,
	[S13] [nvarchar] (20) NULL ,
	[S14] [nvarchar] (20) NULL ,
	[S15] [nvarchar] (20) NULL ,
	[S16] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM2] (
	[SNO] [nvarchar] (5) NULL ,
	[S21] [nvarchar] (20) NULL ,
	[S22] [nvarchar] (20) NULL ,
	[S23] [nvarchar] (20) NULL ,
	[S24] [nvarchar] (20) NULL ,
	[S25] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM3] (
	[SNO] [nvarchar] (5) NULL ,
	[S31] [nvarchar] (20) NULL ,
	[S32] [nvarchar] (20) NULL ,
	[S33] [nvarchar] (20) NULL ,
	[S34] [nvarchar] (20) NULL ,
	[S35] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM4A] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[A11] [nvarchar] (20) NULL ,
	[A12] [nvarchar] (20) NULL ,
	[A13] [nvarchar] (20) NULL ,
	[A14] [nvarchar] (20) NULL ,
	[A15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM4B1] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[B11] [nvarchar] (20) NULL ,
	[B12] [nvarchar] (20) NULL ,
	[B13] [nvarchar] (20) NULL ,
	[B14] [nvarchar] (20) NULL ,
	[B15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM4B2] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[C11] [nvarchar] (20) NULL ,
	[C12] [nvarchar] (20) NULL ,
	[C13] [nvarchar] (20) NULL ,
	[C14] [nvarchar] (20) NULL ,
	[C15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM4B3] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[D11] [nvarchar] (20) NULL ,
	[D12] [nvarchar] (20) NULL ,
	[D13] [nvarchar] (20) NULL ,
	[D14] [nvarchar] (20) NULL ,
	[D15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM4B4] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[E11] [nvarchar] (20) NULL ,
	[E12] [nvarchar] (20) NULL ,
	[E13] [nvarchar] (20) NULL ,
	[E14] [nvarchar] (20) NULL ,
	[E15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM4B5] (
	[SNO] [nvarchar] (5) NULL ,
	[F11] [nvarchar] (20) NULL ,
	[F12] [nvarchar] (20) NULL ,
	[F13] [nvarchar] (20) NULL ,
	[F14] [nvarchar] (20) NULL ,
	[F15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM5A] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[G11] [nvarchar] (20) NULL ,
	[G12] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM5B] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[H11] [nvarchar] (20) NULL ,
	[H12] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM6] (
	[SNO] [nvarchar] (5) NULL ,
	[ANO] [int] NULL ,
	[J11] [nvarchar] (20) NULL ,
	[J12] [nvarchar] (20) NULL ,
	[J13] [nvarchar] (20) NULL ,
	[J14] [nvarchar] (20) NULL ,
	[J15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOMINATION] (
	[SNO] [nvarchar] (5) NOT NULL ,
	[SLOC] [nvarchar] (50) NULL ,
	[SNM] [nvarchar] (50) NULL ,
	[NM] [nvarchar] (50) NULL ,
	[FHD_NM] [nvarchar] (30) NULL ,
	[ADDRESS] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NOM_PAPER] (
	[SNO] [int] NULL ,
	[DNM] [nvarchar] (40) NULL ,
	[PURPOSE] [nvarchar] (60) NULL ,
	[SNM] [nvarchar] (60) NULL ,
	[TOT_SEAT] [int] NULL ,
	[ST_L] [int] NULL ,
	[ST_O] [int] NULL ,
	[SC_L] [int] NULL ,
	[SC_O] [int] NULL ,
	[OBC_L] [int] NULL ,
	[OBC_O] [int] NULL ,
	[ALL_L] [int] NULL ,
	[TOT_L] [int] NULL ,
	[TOT_R] [int] NULL ,
	[TOT_U] [int] NULL ,
	[TOTAL] [int] NULL ,
	[YR] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Nagar] (
	[ncd] [int] NULL ,
	[tcd] [int] NULL ,
	[dcd] [int] NULL ,
	[nnm] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Per11] (
	[SNO] [int] NULL ,
	[DNM] [nvarchar] (40) NULL ,
	[SNM] [nvarchar] (60) NULL ,
	[TOT_SEAT] [int] NULL ,
	[ST_L] [int] NULL ,
	[ST_O] [int] NULL ,
	[SC_L] [int] NULL ,
	[SC_O] [int] NULL ,
	[OBC_L] [int] NULL ,
	[OBC_O] [int] NULL ,
	[ALL_L] [int] NULL ,
	[TOT_L] [int] NULL ,
	[TOT_R] [int] NULL ,
	[TOT_U] [int] NULL ,
	[TOTAL] [int] NULL ,
	[YR] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Per8] (
	[SNO] [numeric](18, 0) NOT NULL ,
	[YR] [nvarchar] (10) NOT NULL ,
	[DNM] [nvarchar] (50) NOT NULL ,
	[SNM] [nvarchar] (50) NOT NULL ,
	[TOTCAN] [numeric](18, 0) NULL ,
	[CH1] [numeric](18, 0) NULL ,
	[CH2] [numeric](18, 0) NULL ,
	[ED1] [numeric](18, 0) NULL ,
	[ED2] [numeric](18, 0) NULL ,
	[ED3] [numeric](18, 0) NULL ,
	[ED4] [numeric](18, 0) NULL ,
	[ED5] [numeric](18, 0) NULL ,
	[EDEXP] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Per81] (
	[SNO] [numeric](18, 0) NOT NULL ,
	[YR] [nvarchar] (50) NOT NULL ,
	[DNM] [nvarchar] (50) NOT NULL ,
	[SNM] [nvarchar] (50) NOT NULL ,
	[TOTCAN] [numeric](18, 0) NULL ,
	[INC] [numeric](18, 0) NULL ,
	[PAN] [numeric](18, 0) NULL ,
	[INCPAN] [numeric](18, 0) NULL ,
	[PROP] [numeric](18, 0) NULL ,
	[OTH] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Per82] (
	[SNO] [numeric](18, 0) NOT NULL ,
	[YR] [nvarchar] (50) NOT NULL ,
	[DNM] [nvarchar] (50) NOT NULL ,
	[SNM] [nvarchar] (50) NOT NULL ,
	[TOTCAN] [numeric](18, 0) NULL ,
	[CANINF] [numeric](18, 0) NULL ,
	[CANENG] [numeric](18, 0) NULL ,
	[CANAFF] [numeric](18, 0) NULL ,
	[CANGET] [numeric](18, 0) NULL ,
	[CANFREE] [numeric](18, 0) NULL ,
	[CANPAND] [numeric](18, 0) NULL ,
	[CANPUN] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa10] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[acc] [nvarchar] (30) NULL ,
	[solve] [nvarchar] (30) NULL ,
	[remain] [nvarchar] (30) NULL ,
	[rem] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa21A] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[s1] [int] NULL ,
	[gnm_nir] [nvarchar] (50) NULL ,
	[s2] [int] NULL ,
	[gnm_lad] [nvarchar] (50) NULL ,
	[no_vot] [int] NULL ,
	[rem] [nvarchar] (200) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa3] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[gnm] [nvarchar] (30) NULL ,
	[seatnm] [nvarchar] (100) NULL ,
	[tot_vot] [numeric](18, 0) NULL ,
	[tot_lad] [numeric](18, 0) NULL ,
	[tot_seat_mem] [numeric](18, 0) NULL ,
	[tot_seat_pra] [numeric](18, 0) NULL ,
	[vot_mem_tot] [numeric](18, 0) NULL ,
	[vot_mem_lad] [numeric](18, 0) NULL ,
	[vot_pra_tot] [numeric](18, 0) NULL ,
	[vot_pra_lad] [numeric](18, 0) NULL ,
	[in_vot_mem] [numeric](18, 0) NULL ,
	[in_vot_pra] [numeric](18, 0) NULL ,
	[val_vot_mem] [numeric](18, 0) NULL ,
	[val_vot_pra] [numeric](18, 0) NULL ,
	[per_vot_mem] [nvarchar] (10) NULL ,
	[per_vot_pra] [nvarchar] (10) NULL ,
	[city] [nvarchar] (1) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa34] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[can_nm] [nvarchar] (30) NULL ,
	[to_snm] [nvarchar] (30) NULL ,
	[seatno] [nvarchar] (30) NULL ,
	[win_snm] [nvarchar] (30) NULL ,
	[seatno1] [nvarchar] (30) NULL ,
	[reg_snm] [nvarchar] (30) NULL ,
	[seatno2] [nvarchar] (30) NULL ,
	[rem] [nvarchar] (200) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa41] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[dist_comp] [int] NULL ,
	[st_comp] [int] NULL ,
	[tot1] [int] NULL ,
	[s_dist_comp] [int] NULL ,
	[s_st_comp] [int] NULL ,
	[tot2] [int] NULL ,
	[r_dist_comp] [int] NULL ,
	[r_st_comp] [int] NULL ,
	[tot3] [int] NULL ,
	[rem] [nvarchar] (100) NULL ,
	[city] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa42] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[enm] [nvarchar] (30) NULL ,
	[des] [nvarchar] (30) NULL ,
	[dnm_pnm] [nvarchar] (50) NULL ,
	[discp] [nvarchar] (100) NULL ,
	[act] [nvarchar] (100) NULL ,
	[rem] [nvarchar] (100) NULL ,
	[city] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa5] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[nm_comp] [nvarchar] (100) NULL ,
	[min_nm] [nvarchar] (100) NULL ,
	[comp] [nvarchar] (100) NULL ,
	[act] [nvarchar] (100) NULL ,
	[rem] [nvarchar] (100) NULL ,
	[city] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa6] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[poly] [int] NULL ,
	[buld] [int] NULL ,
	[lmt] [int] NULL ,
	[tot_can] [int] NULL ,
	[exp_can] [int] NULL ,
	[rem] [nvarchar] (100) NULL ,
	[city] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa7] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (50) NULL ,
	[snm] [nvarchar] (50) NULL ,
	[sale_nom] [int] NULL ,
	[amt_sal_nom] [numeric](18, 0) NULL ,
	[dep_nom] [int] NULL ,
	[dep_amt] [numeric](18, 0) NULL ,
	[no_can] [int] NULL ,
	[amt_can] [numeric](18, 0) NULL ,
	[ret_no] [int] NULL ,
	[ret_amt] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa91] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[matnm] [nvarchar] (50) NULL ,
	[tot] [float] NULL ,
	[used] [float] NULL ,
	[bal] [float] NULL ,
	[rem_con] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Performa92] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[mat] [nvarchar] (100) NULL ,
	[unit] [nvarchar] (100) NULL ,
	[rem] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Pradhan_Gram] (
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[grampan] [nvarchar] (30) NULL ,
	[res] [nvarchar] (30) NULL ,
	[yr] [nvarchar] (5) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Pramuk_Khestra] (
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[res] [nvarchar] (30) NULL ,
	[yr] [nvarchar] (5) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Reservation] (
	[sno] [int] NULL ,
	[snm] [nvarchar] (30) NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[grampan] [nvarchar] (50) NULL ,
	[tot] [nvarchar] (10) NULL ,
	[st_tot] [nvarchar] (10) NULL ,
	[st_per] [nvarchar] (10) NULL ,
	[sc_tot] [nvarchar] (10) NULL ,
	[sc_per] [nvarchar] (10) NULL ,
	[obc_tot] [nvarchar] (10) NULL ,
	[obc_per] [nvarchar] (10) NULL ,
	[gen_tot] [nvarchar] (10) NULL ,
	[gen_per] [nvarchar] (10) NULL ,
	[res] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Reservation1] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[grampan] [nvarchar] (50) NULL ,
	[res] [nvarchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Reservation_ward] (
	[sno] [int] NULL ,
	[yr] [int] NULL ,
	[dnm] [nvarchar] (255) NULL ,
	[tnm] [nvarchar] (255) NULL ,
	[grampan] [nvarchar] (255) NULL ,
	[Wno] [int] NULL ,
	[tot] [nvarchar] (255) NULL ,
	[st_tot] [nvarchar] (255) NULL ,
	[st_per] [nvarchar] (255) NULL ,
	[sc_tot] [nvarchar] (255) NULL ,
	[sc_per] [nvarchar] (255) NULL ,
	[obc_tot] [nvarchar] (255) NULL ,
	[obc_per] [nvarchar] (255) NULL ,
	[gen_tot] [nvarchar] (255) NULL ,
	[gen_per] [nvarchar] (255) NULL ,
	[res] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Reservation_ward1] (
	[sno] [int] NULL ,
	[yr] [nvarchar] (10) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (50) NULL ,
	[grampan] [nvarchar] (50) NULL ,
	[wno] [nvarchar] (2) NULL ,
	[tot] [nvarchar] (10) NULL ,
	[st_tot] [nvarchar] (10) NULL ,
	[st_per] [nvarchar] (10) NULL ,
	[sc_tot] [nvarchar] (10) NULL ,
	[sc_per] [nvarchar] (10) NULL ,
	[obc_tot] [nvarchar] (10) NULL ,
	[obc_per] [nvarchar] (10) NULL ,
	[gen_tot] [nvarchar] (10) NULL ,
	[gen_per] [nvarchar] (10) NULL ,
	[res] [nvarchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Result_Pradhan] (
	[Sno] [int] NULL ,
	[dist] [nvarchar] (255) NULL ,
	[tah] [nvarchar] (255) NULL ,
	[grampan] [nvarchar] (255) NULL ,
	[win_can] [nvarchar] (255) NULL ,
	[res] [nvarchar] (255) NULL ,
	[sign] [nvarchar] (255) NULL ,
	[tot_val_vot] [int] NULL ,
	[run_can] [nvarchar] (255) NULL ,
	[sign1] [nvarchar] (255) NULL ,
	[tot_val_vot1] [int] NULL ,
	[yr] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Result_Pres] (
	[Sno] [int] NULL ,
	[dist] [nvarchar] (255) NULL ,
	[post] [nvarchar] (255) NULL ,
	[win_can] [nvarchar] (255) NULL ,
	[res] [nvarchar] (255) NULL ,
	[yr] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Result_Zilamember] (
	[sno] [int] NULL ,
	[dist] [nvarchar] (255) NULL ,
	[can_nm] [nvarchar] (255) NULL ,
	[seat_no] [int] NULL ,
	[seat_loc] [nvarchar] (255) NULL ,
	[yr] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Result_bdcmember] (
	[dist] [nvarchar] (255) NULL ,
	[tah] [nvarchar] (255) NULL ,
	[sno] [int] NULL ,
	[block_wno] [nvarchar] (255) NULL ,
	[win_can] [nvarchar] (255) NULL ,
	[res] [nvarchar] (255) NULL ,
	[sign] [nvarchar] (255) NULL ,
	[tot_val_vot] [numeric](18, 0) NULL ,
	[run_can] [nvarchar] (255) NULL ,
	[sign1] [nvarchar] (255) NULL ,
	[tot_val_vot1] [numeric](18, 0) NULL ,
	[yr] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Result_temp] (
	[sno] [int] NULL ,
	[dist] [nvarchar] (255) NULL ,
	[can_nm] [nvarchar] (255) NULL ,
	[seat_no] [int] NULL ,
	[seat_loc] [nvarchar] (255) NULL ,
	[yr] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Result_wardmember] (
	[dist] [nvarchar] (255) NULL ,
	[tah] [nvarchar] (255) NULL ,
	[sno] [int] NULL ,
	[grampan] [nvarchar] (255) NULL ,
	[wno] [int] NULL ,
	[win_can] [nvarchar] (255) NULL ,
	[res] [nvarchar] (255) NULL ,
	[sign] [nvarchar] (255) NULL ,
	[tot_val_vot] [numeric](18, 0) NULL ,
	[run_can] [nvarchar] (255) NULL ,
	[sign1] [nvarchar] (255) NULL ,
	[tot_val_vot1] [numeric](18, 0) NULL ,
	[yr] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[S_Jati] (
	[jcd] [int] NOT NULL ,
	[sjcd] [int] NULL ,
	[sjnm] [nvarchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Seat] (
	[scd] [int] NOT NULL ,
	[snm] [nvarchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Seat_Details] (
	[sno] [nvarchar] (15) NOT NULL ,
	[scd] [int] NULL ,
	[dcd] [int] NULL ,
	[tcd] [int] NULL ,
	[grampan] [nvarchar] (30) NULL ,
	[inc_gram] [nvarchar] (50) NULL ,
	[wno] [nvarchar] (50) NULL ,
	[sex] [nvarchar] (10) NULL ,
	[jcd] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Seat_Details1] (
	[sno] [nvarchar] (15) NOT NULL ,
	[scd] [int] NULL ,
	[dcd] [int] NULL ,
	[nnm] [nvarchar] (50) NULL ,
	[wno] [nvarchar] (50) NULL ,
	[sex] [nvarchar] (10) NULL ,
	[jcd] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tah] (
	[tcd] [int] NOT NULL ,
	[dcd] [int] NOT NULL ,
	[tnm] [nvarchar] (30) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tah1] (
	[tcd] [int] NULL ,
	[dcd] [int] NULL ,
	[tnm] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Voter_list_nigam] (
	[cd] [nvarchar] (15) NULL ,
	[sno] [int] NULL ,
	[vno] [nvarchar] (10) NULL ,
	[hno] [nvarchar] (50) NULL ,
	[nm] [nvarchar] (30) NULL ,
	[fhnm] [nvarchar] (30) NULL ,
	[sex] [nvarchar] (10) NULL ,
	[age] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Voter_list_nigam1] (
	[cd] [nvarchar] (12) NULL ,
	[sno] [int] NULL ,
	[hno] [nvarchar] (15) NULL ,
	[nm] [nvarchar] (30) NULL ,
	[fhnm] [nvarchar] (30) NULL ,
	[sex] [nvarchar] (10) NULL ,
	[age] [int] NULL ,
	[type] [nvarchar] (2) NULL ,
	[yr] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Ward_Member] (
	[yr] [nvarchar] (5) NULL ,
	[dnm] [nvarchar] (30) NULL ,
	[tnm] [nvarchar] (30) NULL ,
	[grampan] [nvarchar] (30) NULL ,
	[w1] [nvarchar] (20) NULL ,
	[w2] [nvarchar] (20) NULL ,
	[w3] [nvarchar] (20) NULL ,
	[w4] [nvarchar] (20) NULL ,
	[w5] [nvarchar] (20) NULL ,
	[w6] [nvarchar] (20) NULL ,
	[w7] [nvarchar] (20) NULL ,
	[w8] [nvarchar] (20) NULL ,
	[w9] [nvarchar] (20) NULL ,
	[w10] [nvarchar] (20) NULL ,
	[w11] [nvarchar] (20) NULL ,
	[w12] [nvarchar] (20) NULL ,
	[w13] [nvarchar] (20) NULL ,
	[w14] [nvarchar] (20) NULL ,
	[w15] [nvarchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZilaPan_Mem] (
	[dnm] [nvarchar] (30) NULL ,
	[ward] [nvarchar] (30) NULL ,
	[res] [nvarchar] (20) NULL ,
	[yr] [nvarchar] (5) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[data] (
	[dnm] [nvarchar] (30) NULL ,
	[snm] [nvarchar] (30) NULL ,
	[tot] [int] NULL ,
	[stl] [int] NULL ,
	[sto] [int] NULL ,
	[scl] [int] NULL ,
	[sco] [int] NULL ,
	[obcl] [int] NULL ,
	[obco] [int] NULL ,
	[gltot] [int] NULL ,
	[ltot] [int] NULL ,
	[rtot] [int] NULL ,
	[urtot] [int] NULL ,
	[gtot] [int] NULL ,
	[yr] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ele_loc] (
	[cd] [nvarchar] (15) NULL ,
	[dist] [nvarchar] (30) NULL ,
	[tah] [nvarchar] (30) NULL ,
	[grampan] [nvarchar] (30) NULL ,
	[inc_gram] [nvarchar] (100) NULL ,
	[poll_statnmcd] [nvarchar] (100) NULL ,
	[poll_placenmcd] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ele_loc1] (
	[CD] [nvarchar] (12) NULL ,
	[DIST] [nvarchar] (30) NULL ,
	[TAH] [nvarchar] (30) NULL ,
	[GRAMPAN] [nvarchar] (30) NULL ,
	[INC_GRAM] [nvarchar] (100) NULL ,
	[POLL_STATNMCD] [nvarchar] (255) NULL ,
	[POLL_PLACENMCD] [nvarchar] (255) NULL ,
	[PAR] [nvarchar] (2) NULL ,
	[SAN] [nvarchar] (2) NULL ,
	[APM] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ele_loc_nigam] (
	[dist] [nvarchar] (50) NULL ,
	[tah] [nvarchar] (50) NULL ,
	[nnm] [nvarchar] (50) NULL ,
	[cd] [nvarchar] (15) NULL ,
	[bno] [nvarchar] (50) NULL ,
	[vno] [nvarchar] (50) NULL ,
	[poll_statnmcd] [nvarchar] (100) NULL ,
	[poll_placenmcd] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ele_loc_nigam1] (
	[dist] [nvarchar] (50) NULL ,
	[tah] [nvarchar] (50) NULL ,
	[nnm] [nvarchar] (50) NULL ,
	[cd] [nvarchar] (12) NULL ,
	[bno] [nvarchar] (5) NULL ,
	[vno] [int] NULL ,
	[poll_statnmcd] [nvarchar] (100) NULL ,
	[poll_placenmcd] [nvarchar] (100) NULL ,
	[par] [nvarchar] (2) NULL ,
	[san] [nvarchar] (2) NULL ,
	[apm] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[voter_list] (
	[cd] [nvarchar] (15) NULL ,
	[sno] [int] NULL ,
	[vno] [nvarchar] (10) NULL ,
	[add_hno] [nvarchar] (15) NULL ,
	[nm] [nvarchar] (30) NULL ,
	[fh_nm] [nvarchar] (30) NULL ,
	[sex] [nvarchar] (10) NULL ,
	[age] [int] NULL ,
	[del] [nvarchar] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[voter_list1] (
	[CD] [nvarchar] (12) NULL ,
	[SNO] [int] NULL ,
	[VNO] [nvarchar] (15) NULL ,
	[ADD_HNO] [nvarchar] (15) NULL ,
	[NM] [nvarchar] (50) NULL ,
	[FH_NM] [nvarchar] (50) NULL ,
	[SEX] [nvarchar] (10) NULL ,
	[AGE] [int] NULL ,
	[TYPE] [nvarchar] (2) NULL ,
	[YR] [int] NULL 
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

create view Mast_view as select a.dnm,b.tnm,c.grampan from dist a,tah b,Grampan c where a.dcd=b.dcd and a.dcd=c.dcd and b.tcd=c.tcd and a.dnm='' and c.city='N'
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

create view Mast_view1 as select a.dnm,b.tnm,c.nnm from dist a,tah1 b,nagar c where a.dcd=b.dcd and a.dcd=c.dcd and b.tcd=c.tcd and a.dnm='uSuhrky' 
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

create view temp1 as select a.*,b.sno,b.vno,b.add_hno,b.nm,b.fh_nm,b.sex,b.age,b.del from ele_loc a,voter_list b where a.cd=b.cd and a.poll_placenmcd='ddd'
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

create view temp11 as select a.*,b.sno,b.hno,b.nm,b.fhnm,b.sex,b.age from ele_loc_nigam a,voter_list_nigam b where a.cd=b.cd and a.poll_placenmcd='fjkgkf'
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

